SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 24313 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 24313 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31831,353964,183492,941026,510438,293259,872741,142838,188971,563208,653674,503092,365117,284949,813903,757463,327701,508364,957595,443554,476402,412676,702980,861852,303302,518513,340677,243978,932319,752057,1009473,511479,10010,4870,242122,213418,345206,803052,25016,259059,143266,20181,68770,649993,10157,367584,416684,795994,880021,650338,746326,164855,979082,427197,348307,959434,799109,669357,262069,652643) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 24313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 24313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001574s ]