SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369462 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369462 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812805,153993,958354,327252,1034402,125400,325273,848482,754314,375791,424509,358711,90187,273999,956539,581102,662840,828482,636208,750997,322634,185929,746910,222244,847326,352950,629780,57737,116746,11905,647959,562958,334157,439674,856403,472092,85173,844487,554342,746941,1002839,966603,73251,140091,590445,959992,416481,960232,694153,294190,700930,870703,874271,524717,872536,802880,964215,132654,93511,459028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001426s ]