SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458081 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458081 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646849,78139,277063,38668,169604,717334,374514,373514,143222,357440,366946,270302,263484,93954,1029071,155171,564685,949310,601797,868390,1012844,383680,118014,488112,1043353,130174,699405,745640,647584,433508,224993,903194,210303,963500,501569,391208,629316,99882,717193,92946,153171,224350,317573,303088,911320,623994,319271,153470,30216,200962,282799,460057,1019340,784660,264332,759637,663173,447826,722113,104899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]