SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 818860 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 818860 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885808,739884,208715,690949,930657,405546,508625,54801,587118,92416,130618,69520,954388,845176,625343,235017,374413,904440,993657,705708,446621,983762,750577,933305,303983,98151,487615,285039,960531,990554,1013808,525517,484207,364038,792416,1002232,226044,183768,312446,994731,271999,730587,292120,649650,244532,681816,255793,359084,1026549,385089,556200,327548,868975,730229,567495,148068,274516,1024580,568875,687483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 818860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 818860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]