SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002767s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473825 LIMIT 1 [ RunTime:0.004146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473825 [ RunTime:0.004960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414111,409482,406223,261145,669812,126870,871615,953373,46249,1011967,326631,593839,715027,203973,641184,103522,404117,132080,570729,448115,316643,748743,1007498,610916,249448,1047281,500120,655532,828168,836853,102713,156517,784783,440142,996960,353495,950600,720416,773016,99645,144179,658846,426709,23003,444914,777330,815380,469536,730723,441165,112114,930747,715552,81133,767867,171690,705466,119068,69666,473912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]