SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498954 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498954 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685470,702914,471296,229247,616603,560450,354102,102809,839502,868430,485136,405073,452267,1042673,942246,573949,1017019,139960,1041459,647227,672220,626849,285332,577355,99831,129726,896167,499498,269444,932685,418949,249895,548940,990340,552501,680086,724579,6635,754082,992938,461361,444776,333156,632031,775047,474611,945572,187385,408592,565491,762645,992054,278979,771100,121070,982017,227439,69133,807631,258283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]