SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642011 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642011 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26266,451537,637746,272418,272876,538229,755254,738104,477590,364286,645558,173945,179772,895873,782543,748849,39772,250839,194389,99540,602894,197244,80140,95631,164843,130697,436276,967644,267344,489871,690643,330299,779020,290634,558670,671487,738504,813434,239231,294749,867567,450139,514904,780630,329983,532501,732782,968697,20583,732170,167489,482869,379104,724261,159606,16400,463350,505067,786596,695372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]