SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040922 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040922 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565477,499035,209678,550296,694244,2832,219797,994368,43523,820718,726567,17113,103323,285415,583115,524677,413563,327116,973662,181291,438982,602578,388363,36488,61126,111531,118737,751592,567025,716348,541558,729912,828665,361016,65852,932048,337450,446360,522958,448851,149910,500538,613605,227326,223850,120974,182300,233352,815254,325243,682467,638113,675519,242604,41124,98724,670926,1038467,403027,979963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]