SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410718 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410718 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959432,768518,553800,299326,620420,199789,698261,750768,106651,94527,981648,385808,249322,110851,151125,994367,893037,159056,827588,912345,630577,2841,1014683,880601,890362,454443,177524,487160,108699,567463,959482,962782,537671,434508,747220,50087,895122,315152,807948,769449,109631,281021,492347,843986,576102,421886,591629,504035,923660,486262,26101,233441,379103,513187,234613,765908,847860,935789,473549,406652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]