SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575096 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575096 [ RunTime:0.006436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034303,241434,1023182,313248,259549,89601,120836,898793,131672,861727,213537,525389,446249,30859,137243,103687,679262,858313,12861,859819,278261,520858,623607,384677,244455,157153,1038242,1000072,602573,413490,753148,868975,218708,212565,13935,856873,158535,331995,986828,200149,857446,1009255,293688,245228,148897,178294,922806,155411,487572,684369,702661,959383,67314,650428,820648,445383,1034301,351681,605214,288751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001907s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001225s ]