SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510575 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510575 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737424,779471,62113,36593,880741,632782,1008951,678662,732912,784233,100519,485983,700302,947525,551035,988104,223805,820910,76639,165596,267564,645718,431745,702034,343568,415802,63829,1018529,1008423,786161,313456,716838,120913,767558,664607,787110,770411,910681,80901,921856,1037009,287173,299326,41508,676467,803213,16141,135375,262726,13270,544279,594984,665271,520485,85258,539596,463691,1020120,331518,868172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]