SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427850 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427850 [ RunTime:0.004443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169602,976297,1000866,836456,709561,940693,503589,935066,665227,318890,491911,28761,762670,846792,248674,1076,382347,164471,680954,157039,847861,681380,460372,649372,289305,1021384,974910,231172,420417,861400,865825,124056,880032,935475,348974,1022405,840585,321787,538107,129722,69073,760180,969549,854562,170398,329048,535750,712543,325113,866378,437194,992938,617304,129059,434070,186503,83842,1006496,6049,768207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]