SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473517 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473517 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582270,803351,132011,322781,201959,397159,137865,149244,304540,735300,385662,638762,414332,401373,432465,810342,895955,5750,338540,845788,31217,621615,550741,903065,824733,72128,661289,535051,437912,1001367,840564,191834,1007358,501525,550743,53433,367187,744533,847901,168985,712511,419468,543116,406187,396436,381031,94764,274123,462834,225964,313088,708206,741383,1192,649898,919500,777407,778865,790418,926374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]