SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026473 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026473 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736572,1045772,105364,487958,201339,161846,449880,294053,377503,575345,791244,705677,591981,525938,499156,330871,212343,248211,141226,185403,692443,186234,659886,318526,105538,852078,792059,827362,769422,757603,229580,907024,190778,125854,869640,60601,385394,780297,522380,1043522,289574,9071,252874,100325,961840,753683,438231,330713,351248,35286,633691,835955,514822,98862,79416,345563,291267,699764,141040,270527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]