SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399578 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399578 [ RunTime:0.001227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480031,131733,110543,212947,1023539,478875,116882,127092,378043,519206,209203,40220,315308,838348,1035077,255593,205098,27098,864149,429077,74893,701840,529370,358,711491,212126,315293,622384,728097,762867,138503,559443,561503,485660,875649,578522,707722,475969,490733,19207,694130,127562,246237,61674,480988,74920,463965,704026,672629,933313,176888,888294,859974,817012,272949,316991,191817,167336,862379,258116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]