SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910014 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910014 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271575,1022709,165102,992176,524051,435204,814276,163716,110504,474720,451764,514184,250400,982074,83916,240321,879612,941023,373520,618745,393551,278730,115425,347668,673646,876094,574814,622004,808985,86038,279506,702811,359253,310911,383849,801438,745262,113829,717314,106298,322972,715497,911988,931732,92891,284088,823919,830758,13854,1020708,979122,1043968,317771,354057,367334,722713,992702,549016,779987,557878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]