SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471970 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471970 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108466,438805,986067,661757,753085,160737,639626,733483,180663,363862,512994,210850,416198,635812,7883,782314,705621,835090,619936,654824,650536,393288,498638,802877,568284,328255,681802,813456,310851,453555,492636,277256,1032729,217228,447027,47271,452873,1042624,11932,802601,951510,720769,832919,490984,42076,996051,739090,482660,334199,326660,404400,116382,854818,931913,854666,49611,604345,412621,147409,492427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]