SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430038 LIMIT 1 [ RunTime:0.000770s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430038 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482417,726837,881488,12023,136956,390459,321886,643584,215374,219159,638355,659164,68782,837309,143905,412433,230124,958641,130023,766291,996208,976654,138807,925076,18045,259325,307078,795426,805926,755674,1033192,378544,440303,400626,749545,324199,47820,934773,704880,969324,764117,705692,616539,287481,159189,441547,522878,166550,953710,707809,863089,234513,421856,945922,515019,880656,953065,886670,562976,274096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]