SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542612 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542612 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427587,941196,942268,82342,481388,420340,939440,941836,2181,54759,893942,7600,292069,139251,715929,32937,482667,671148,980877,324253,542427,444416,648673,384685,345968,659126,122405,830970,997285,973056,182513,280593,110883,1025534,61094,223732,327914,786951,448477,971065,361980,485303,353042,2711,908515,136368,592981,897252,439260,507803,66244,94772,63666,834078,583934,97891,804789,346075,667687,912992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]