SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496694 LIMIT 1 [ RunTime:0.003114s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496694 [ RunTime:0.002992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408995,222601,443874,722155,391152,47539,733249,571461,19717,118325,219589,798284,317380,252905,436885,642447,316772,523749,50763,649098,180738,640367,535664,210672,372233,392670,807828,686704,252370,98531,58306,41876,789496,309199,250592,766395,507862,267859,1021776,662476,1030925,457641,693022,823136,581856,794118,329162,812467,958311,890114,783794,947658,420316,80154,629801,757639,792752,518883,292837,152060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]