SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301940 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301940 [ RunTime:0.002587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972681,829072,581447,998123,703177,134629,41735,232512,646295,335260,255722,707546,627874,78920,505313,60777,171415,336430,107914,896887,290887,443544,845945,398990,610215,494047,460297,466123,862137,1048522,6017,765569,852096,924996,275804,351505,855856,565708,370962,341514,597528,742589,43047,253806,704462,1031742,424773,989246,548016,781338,24712,28340,711991,156232,154277,875461,958613,230053,910789,952809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]