SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204573 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204573 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595788,720384,456031,999199,352477,1048139,464219,442232,169605,507103,207918,629081,980495,673513,873806,322650,358052,107472,628004,654750,23851,760200,556441,949895,569140,281242,902265,439873,939634,955223,1386,573523,321200,309254,454539,670862,947749,704144,726873,5338,842995,82110,821714,219177,9079,268722,781555,657559,741571,549092,653224,500372,234635,499566,189270,647893,819540,586687,937530,629427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]