SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010471 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010471 [ RunTime:0.002597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032412,613122,28676,1029844,207075,76300,94724,814825,421533,602263,663535,681913,708410,480811,824814,19902,144758,927720,224853,711959,785612,614282,225239,395514,822168,588901,523276,914443,699144,693099,256601,283260,454153,991779,656385,674598,591860,26314,702601,816106,459733,20796,336437,707921,547484,31882,784781,471932,904182,570097,242871,1035313,725307,280042,580690,975917,654107,367234,711197,694351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007393s ]