SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000148 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000148 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867975,639684,247344,232503,713559,374111,595713,913755,101769,985985,438420,786522,872579,454835,334938,728180,185315,343729,123380,842196,582380,144975,865554,556624,825351,828263,601046,107715,29413,999023,332818,1033086,38204,860184,467384,436831,869963,883894,744988,498258,982233,21531,569861,356083,113652,240294,315261,750572,589818,801280,718341,884655,46150,513192,901151,199610,587933,171133,728945,843342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]