SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286250 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286250 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814529,130981,459808,441315,636608,395984,878572,473593,157555,104983,903476,809411,22908,414794,853892,533838,87649,442775,143687,392435,312166,952214,131903,33463,58940,20085,133451,726455,474528,205110,265802,1023909,911839,451428,447389,609655,486821,730567,185149,247199,313252,130091,952648,920549,392985,897134,726411,671695,405667,361937,711856,445438,295275,332581,339665,597473,892888,509306,220462,970078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]