SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029210 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029210 [ RunTime:0.004199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388093,444773,3647,422709,239052,944236,446552,845896,679435,64268,911500,920310,344860,49219,144733,1046735,717255,8543,603334,839331,708236,765933,750109,456027,209058,41821,353995,541472,571213,990521,540711,763971,597430,33475,716775,894389,734262,74033,772788,830581,823204,280609,342939,199656,367462,647702,473904,704095,778324,581945,925124,859576,261392,280606,699012,629275,791862,899756,178557,1038992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]