SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101713 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101713 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878362,65826,120362,241710,158753,279883,836116,550650,736753,316575,888919,447708,213336,659946,1026307,883527,247933,398329,379393,436635,399087,481499,661207,929842,592445,358847,237770,88426,602159,114670,662263,768318,503419,495318,878094,647319,794977,668678,258098,129668,838744,328979,878154,859271,247155,294012,803590,1006990,502443,641339,769681,670391,834678,683961,671081,963406,373199,814645,25765,341579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]