SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190513 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190513 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536160,925906,342186,955473,578930,97979,237931,835737,749729,1042610,232561,512778,91805,556247,902446,888659,55638,83352,58248,478653,109921,728427,387892,916133,352763,757128,741817,357903,1014942,463318,174548,641392,300392,927163,426153,601321,542960,897154,351990,51395,765403,596618,593521,470742,207473,528192,758791,79099,149190,839160,960421,593290,406106,724640,626825,1022167,964347,290107,59561,907956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]