SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023089 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023089 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562111,92591,79491,112586,34145,151119,1032106,94664,282116,25042,467197,50730,749431,495506,1041542,10652,900466,555782,98542,436016,399253,129778,421648,684513,189926,305259,575477,337703,199046,109978,617529,576256,29736,769621,879526,538913,661814,390537,37410,1027322,494271,646219,534100,237848,562773,1385,156012,873974,669231,446751,316123,181092,546691,785210,283015,234325,591580,530726,77454,245646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]