SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023670 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023670 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559430,433815,849189,389794,441121,180868,607143,302154,71639,487660,116934,436072,681262,205879,42279,869465,166058,57047,137301,307327,864357,633851,658123,620184,750293,53405,490952,710067,31771,505076,619487,201670,434379,1047325,102831,268628,37240,1029573,138256,1008331,864567,887315,839545,327885,424414,936583,1001841,715517,221349,459425,894916,963687,956483,709786,75522,773916,849645,958314,616799,579129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000922s ]