SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405528 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405528 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879305,570662,441243,788633,940974,846371,2523,689,928686,51654,320095,33361,828245,842328,112598,998058,1030025,757368,827856,734107,1016685,993621,710589,249517,732754,255000,716324,239474,107290,492377,1031776,459194,840718,185228,140572,135992,1048408,467558,152615,100998,1035603,116524,449099,43977,464224,562226,879792,762099,632993,609441,591992,1006307,878599,788852,934271,562453,521666,823795,3394,381391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001196s ]