SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561226 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561226 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522699,4514,851819,83473,549907,300790,642588,795261,972910,213221,338930,958138,182072,701877,806477,928981,620553,39048,862883,272059,474716,295766,524231,998157,128611,785030,968975,528470,21715,761142,1039182,186189,931606,893273,894549,172108,710295,696892,745903,106619,1023296,539969,26082,703606,890394,757020,398215,2176,707262,242710,373676,989361,607215,604768,437250,338698,1015794,591375,325940,584776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]