SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53164 LIMIT 1 [ RunTime:0.000891s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53164 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759853,272764,492854,378955,926313,114696,464380,839019,559748,564806,7240,776096,226062,876676,1025782,838216,501126,923902,776760,964346,343550,940743,203337,984353,30597,370896,566229,245479,410236,353147,426967,362501,869652,131348,699131,368987,672289,158462,283070,410859,535872,460079,1014762,226630,477808,276417,734205,7734,679442,200442,1016892,1048258,911704,423696,238736,591984,157431,213567,87427,324039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]