SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002835s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004391 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004391 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709711,254177,523800,606543,373435,1010390,160471,65039,342445,218407,283861,891022,703631,93581,373268,908199,32199,307601,616619,898642,782366,1009965,993022,770590,651097,202912,771838,106849,858896,574474,1024155,868745,890689,409764,561474,1001490,985326,730387,799032,109644,608123,37432,828563,571180,1001543,24462,776681,630196,460498,17866,643350,442939,748180,425469,781589,620458,615635,984,495616,1033436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001845s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]