SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35142 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35142 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812727,575314,314631,457520,348303,746394,573988,201794,558998,522407,446516,107693,26056,913366,692902,926011,472339,668178,883675,707703,693410,126638,16014,674370,1040540,242876,1033926,433988,615644,422714,207489,402837,666782,808459,344636,931696,317477,86223,1027681,891562,554897,697994,310635,555266,97098,467342,103496,65612,95969,891305,348830,898196,14434,205218,597944,823812,464126,398311,670952,943897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001648s ]