SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584100 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584100 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664451,182664,785203,511268,633508,947841,126819,977286,480182,844173,65601,1007408,407318,446349,172935,1022550,316646,254579,764172,271902,203151,739007,330626,540202,86071,202444,1048178,983346,277448,14417,574672,411924,1045952,783084,552078,546303,166929,26790,863150,204700,298921,517233,618022,858875,727338,962133,352231,128161,779426,851956,121459,229253,237758,452573,1048722,38316,23930,623761,80750,1031765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]