SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545028 LIMIT 1 [ RunTime:0.001146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545028 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515426,699169,671127,1046534,228641,613371,702425,358336,102657,387840,96010,429205,322207,126105,420517,970009,785442,498571,602574,842463,203047,374615,851225,841397,577626,354668,41855,137143,453663,974426,73027,676877,599973,519069,493123,41229,531900,289244,396138,946085,995737,677661,376683,666762,1046230,111421,599976,829430,691687,597368,5688,652753,599996,585486,936168,318592,780310,258519,342402,803664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]