SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444217 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444217 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570135,196433,574391,463842,561694,992583,299469,216008,102453,608797,1031886,510877,91039,188519,497923,88937,373747,868557,973312,762732,82280,93841,173071,925691,429345,590005,193674,945238,848121,550747,356169,249465,912946,877107,972407,741484,922827,558114,250949,452822,321330,571976,115291,818729,889933,835691,748493,642656,686816,736678,991358,36921,286715,346567,960441,600545,161956,649900,963633,304765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]