SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460415 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460415 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350063,290820,255006,502865,108443,922426,1026552,271158,1048356,589287,515048,588952,1015812,423091,909203,639038,762635,664389,328678,646440,427307,532627,387773,362051,97619,409002,39575,556184,724475,190147,484083,2340,764962,89529,364216,338301,220783,527204,591568,328394,499367,207328,888392,477091,1046581,543880,261343,936122,683821,886429,711267,758065,262387,971243,940218,725253,181839,652544,746359,677274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]