SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685215 LIMIT 1 [ RunTime:0.001450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685215 [ RunTime:0.003701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38422,411008,280996,998489,565449,927373,999022,895455,337156,281164,615355,556608,454202,454404,201149,377864,373656,612830,44856,289497,619744,405121,160980,1031345,834435,390389,393209,546008,759840,863560,821895,1027162,590834,833338,62668,912110,359790,281001,650720,910592,622768,148826,448761,20723,616716,150426,12770,354403,114455,839081,520272,894071,665071,657685,837108,244505,630982,926981,1033982,109818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]