SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50810 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50810 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670417,206096,921090,305403,1015079,1001173,364471,823253,708959,524165,827852,1018247,612042,536738,56934,444420,502946,606813,567039,502708,444666,488829,1009393,429090,23628,830083,670856,1033604,783290,332361,439505,642792,712558,553283,1024547,84195,449476,814424,234460,286788,917464,1024687,20420,407277,74700,169948,12916,400500,1021070,119389,418546,233924,51360,537753,738017,42923,101395,1013472,670909,586358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]