SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531628 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531628 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237483,63109,155538,408862,793018,797610,434697,35277,511972,258421,310153,451909,669409,222788,73649,341301,836651,78023,172578,203917,912410,743221,686786,717341,545312,712026,875778,953296,178933,23179,291766,597479,781080,402604,906886,333643,61939,354818,784995,1017198,663887,831771,198439,536750,871081,388909,352885,885800,144370,31735,263177,529053,611883,1025323,632618,568930,438516,113121,1004787,9185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]