SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417841 LIMIT 1 [ RunTime:0.001004s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417841 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605961,917993,310935,946240,810187,991548,50789,782437,179399,437599,390636,163841,961062,790079,468276,595506,161108,651578,715759,228829,572350,758612,256257,327685,33185,224666,362494,373296,956623,532033,842210,174495,638302,679011,281421,701041,989325,653057,570441,319862,183233,848656,251316,403159,1045413,130110,326250,397745,492343,382495,406619,364364,495964,316186,629476,364981,814293,589373,557785,781301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001584s ]