SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300017 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300017 [ RunTime:0.002734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561087,29901,732711,503925,973677,1009874,583358,589540,32283,635416,706936,991469,905382,838631,726081,679923,318451,958159,130598,916153,1015708,380658,77686,387584,670852,723372,1257,914474,948247,392160,853264,410759,973349,484675,426190,644764,984381,269057,507548,144801,405564,56995,987452,182382,131360,117071,889138,871771,1019180,548336,959100,229488,778501,804757,103915,441911,905849,876276,176465,438299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]