SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148291 LIMIT 1 [ RunTime:0.001283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148291 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181270,45911,370573,248474,681379,862920,333551,966151,551033,754394,634745,952624,136828,575135,1007436,176069,221048,577179,46610,930865,702983,900274,939151,571582,275047,980079,161186,205272,936751,443175,337929,550738,125849,306997,1012279,893945,558523,92881,679193,16129,653610,523171,656060,126804,759043,776414,99196,255799,866860,682284,516548,493097,196900,1021633,753692,488455,441316,21398,11980,602619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004462s ]