SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498177 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498177 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002375,995787,542177,469893,1025720,91373,546997,318938,209124,220885,1038483,23659,548273,56231,456855,259650,247607,327428,1010589,124348,242823,671523,559045,141456,182334,981869,107589,206854,664634,321327,516510,197892,495580,931711,187302,746665,417758,105833,115961,345446,802700,281891,40485,313777,334632,1014237,454683,443695,1002826,582410,309978,233778,952542,334583,505025,935902,726239,853628,714340,1029067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002167s ]