SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534496 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534496 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907267,284692,917851,206567,840899,328444,906608,1005128,392233,712268,86990,778585,514274,224806,670554,307807,661887,568621,279645,190229,857555,133537,229837,216250,917045,471639,580338,784466,984852,50234,239034,545990,983209,437471,486371,190862,525336,784143,776965,56999,402345,398185,199386,783772,220101,280893,141904,500522,992937,63542,579643,312285,531372,378465,945960,344640,81220,561294,868648,784253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002710s ]