SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50918 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50918 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629176,394704,604548,205482,850229,283387,456350,587997,736519,796925,975606,938456,374204,449081,108310,655464,699171,29381,140309,210645,726267,29880,426055,942265,917397,483589,858582,834137,130030,167944,203851,473552,672542,879974,260132,432727,1028680,549191,164342,780607,234622,502201,992004,745574,642703,35690,577039,690180,1033147,490706,964171,391272,207696,735692,79926,936038,151587,237951,399418,209318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]