SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 963142 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 963142 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587847,141244,1028351,364800,552647,322071,715279,515900,361712,388316,740057,991767,949587,155583,403696,509055,791348,990435,136098,416436,403417,630921,954339,954265,1735,187981,283910,482603,349796,930,683007,692826,175477,438558,920795,110191,357534,335693,89720,311048,718548,368922,815851,464439,930033,288343,952882,452890,1037386,639224,500495,340089,248713,604918,524029,1039911,878834,298441,960929,806731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 963142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 963142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]