SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312308 LIMIT 1 [ RunTime:0.002063s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312308 [ RunTime:0.003306s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309679,73886,797779,415845,988534,849406,986221,554064,12837,970640,412265,156343,16678,173269,321072,1038258,251715,641299,398681,381279,216355,986960,203422,836090,999360,80631,508896,830738,1002066,312394,212498,325667,927245,736842,812083,805631,228089,553149,330543,169447,345809,306473,955712,16595,645977,426009,864130,773957,823936,698173,282991,746599,393508,953283,966265,5867,949324,119635,834352,1018602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]