SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305404 LIMIT 1 [ RunTime:0.001293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305404 [ RunTime:0.003436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026730,703357,244225,395247,891070,662597,503973,558205,498349,985774,105291,622070,145052,240024,235048,991915,438816,1036816,174022,15236,364208,675562,153804,72394,508643,262586,722934,31737,860954,870484,144185,220231,629717,478764,974062,512997,374241,227902,942903,458078,211601,473431,179173,426234,489610,581315,977824,371737,357568,296115,440239,241977,146814,156964,194996,990409,224097,577430,67405,917245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008913s ]