SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148440 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148440 [ RunTime:0.004854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119194,82017,57149,546762,645824,496164,780213,920710,389334,798555,115323,907059,725004,476360,546455,31849,785208,556898,769626,527462,794380,708261,575530,925557,851892,49194,417325,654103,67283,924751,957760,1006894,278159,921614,185383,738319,390196,733093,894410,880768,764473,433647,670783,641794,150546,15228,582258,992112,445373,209227,770228,76146,4942,351662,950293,132353,265417,46224,118810,834583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]