SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504094 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504094 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390823,1028581,501553,226555,398108,1036218,302636,464831,720716,672919,972942,707222,1035101,1046760,518758,302468,183322,536094,141250,726808,465825,949101,82177,664280,929368,581729,621732,353216,661942,816417,952852,807399,969544,224828,1021506,590645,477416,497269,289144,505442,684803,815206,387104,308628,647858,914777,785841,438629,164835,1006498,986748,808960,962357,142477,972160,595761,360496,313381,1027403,642124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]