SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292308 LIMIT 1 [ RunTime:0.003987s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292308 [ RunTime:0.007389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102060,383445,382211,399635,613918,1000757,976967,662183,159119,397675,344699,762774,458411,746763,250877,656578,73424,865993,662132,376153,624098,469208,898169,48764,951861,191898,333696,273151,796448,770735,764891,802583,367888,39037,617640,70295,589599,740296,115836,448840,600665,339758,211820,583365,474910,227137,488475,434231,823251,950722,139461,591661,196196,230541,391242,265161,886195,364109,920781,489532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]