SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407189 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407189 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527737,188918,806076,12838,237660,557002,595982,606081,257780,365522,586049,69990,342806,378775,601445,160495,62891,483014,843293,486124,531977,398502,394806,204240,653553,691237,875225,612119,632615,84963,210210,516472,652006,953257,78645,171060,478594,40463,517800,86307,658377,955895,437214,679081,190572,951232,250348,865955,376798,341170,366685,686981,154142,260645,939211,546939,620319,788676,545293,1016386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]