SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386713 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386713 [ RunTime:0.002901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537909,14680,767116,128185,174392,685070,401569,366777,641311,248469,23071,719838,527445,344932,72257,816950,613640,232170,251516,668895,906933,131580,317041,335032,411150,1030995,656154,878508,314163,256775,528001,624066,1028379,232412,863255,32394,190878,78835,787105,892353,391228,405406,790979,129236,173976,158662,208001,873289,304332,537624,757882,837839,904541,833229,696882,285916,895251,84543,119983,27389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]