SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040313 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040313 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635081,656448,583923,916191,690033,501429,109020,260310,495407,793438,318887,584264,853330,8535,264584,23680,291951,993624,668835,884283,892254,13182,4677,527497,991451,656912,716658,790895,2653,346270,335579,477405,555298,22721,213526,781831,464435,35891,212645,51122,892236,481310,659166,77974,933152,604486,756585,943302,820141,385144,738903,32560,712909,990485,12775,198838,324779,91956,306010,836396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]