SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499104 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499104 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708003,437997,12650,1028706,540873,977293,22371,18035,149756,408859,108811,714225,860854,608294,460788,533485,62954,482839,114567,177394,1034106,73288,687928,941203,899960,832853,186352,804336,77444,497557,420067,121037,873580,758211,745911,10735,651729,129200,16897,65395,265384,71927,702647,279897,414217,736635,98298,206768,735263,52984,842895,966715,617903,593188,299244,695734,265926,1018694,67432,127229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]