SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 885314 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 885314 [ RunTime:0.003242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354318,1012118,86741,862273,176364,276465,55107,991051,761636,33061,356711,990910,201871,790996,656296,1010350,499414,261945,490375,180337,939379,413314,984575,485227,155005,900066,185856,28508,199529,112788,832643,24300,472574,71004,912767,444458,561355,175906,201795,133047,824510,952068,45019,102662,35798,1029465,791358,902851,505236,1042564,753829,16401,1018276,360504,206504,734236,249355,546427,892961,509741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 885314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 885314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]