SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 701940 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 701940 [ RunTime:0.002638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502906,100134,419654,484546,536982,675744,551212,360858,871601,12579,214900,3814,641705,654188,767298,146827,740150,137824,465446,433994,504724,627924,453869,811870,462209,151945,537860,638501,776553,70653,220394,628369,898573,222018,472012,16223,341763,492229,940649,5854,329310,412190,37825,665448,1010692,509017,29452,953177,774209,638143,789344,388069,873457,1000671,749204,408427,203975,789587,82330,71720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 701940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 701940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]