SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044660 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044660 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646441,980607,151116,47048,179774,651842,179151,581855,826084,575732,960253,272299,164108,730709,7992,192786,563553,746791,459912,543846,872899,840188,209490,632641,670103,923404,809233,73783,745264,222958,933350,432974,8203,205326,372840,393575,195208,447234,903510,777043,223505,479824,387042,219041,849174,1013852,29533,194665,267235,824854,756069,679269,986581,689632,719023,244152,87236,543968,1001063,681550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]