SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502215 LIMIT 1 [ RunTime:0.000752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502215 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685416,142164,1036852,879641,145850,521441,241760,649284,113750,577776,53114,328600,529545,297732,551929,555556,491900,80948,933283,491218,88884,545440,890229,479771,359205,522778,249984,825061,376527,293666,70606,788283,614538,285595,980520,726768,502799,883468,367951,537578,731778,605893,206253,44461,131001,522441,81684,106577,617652,568394,254194,713991,523346,768399,70563,567162,981581,47862,279745,714172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]