SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011287 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011287 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004368,570067,354598,94060,210531,976141,294438,275258,211039,366581,179857,745761,626417,714704,227440,537740,618950,637379,291095,460323,562280,47761,122439,961031,768063,637690,841626,185115,718525,1036277,2375,975345,124879,1000505,178249,948828,744394,919270,296467,996338,198115,722222,508703,781841,497614,190314,308826,217233,635220,149874,809211,393271,896437,85893,670268,741422,1038954,711576,298045,651734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]