SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120401 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120401 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52007,915822,270369,357918,260732,191597,554058,62715,561414,417113,339746,1047153,774597,35530,183749,430793,786111,342552,57723,737951,826944,243445,409318,809157,500640,249187,897019,212332,91206,984742,503353,606193,238775,647464,777305,999510,413204,657264,139397,376743,148886,723982,247782,569765,502186,931457,374874,899433,53003,860786,265596,621138,883187,494110,579444,134851,676463,284979,374675,382270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]