SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478730 LIMIT 1 [ RunTime:0.001715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478730 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532220,180639,838202,176336,561315,941592,672725,800411,241839,248891,178880,354061,19791,556289,74433,501609,344440,737502,506278,254856,938629,43560,104138,741593,796125,869869,393224,201004,1028819,986953,913767,778380,753714,352268,868252,286472,119856,111476,43150,15341,902803,534352,962622,29465,627272,71530,462443,290927,188091,276705,368779,365881,430050,309865,182089,223681,317940,45231,255608,526526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]